Name |
|
Code |
|
Comment |
PL: Dane pacjenta |
Name |
Code |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(24) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
wartosc string przechowujaca dane |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
wartosc string przechowujaca dane odnosnie |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
wartosc string przechowujaca dane |
Name |
|
Code |
|
Data Type |
VARCHAR2(2) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(2) |
Mandatory |
No |
Comment |
Numery duplikatów karty RUM (wartosci 00, 01,itd.) |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
FLOAT |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
FLOAT |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(12,4) |
Mandatory |
No |
Comment |
Powierzchnia ciala pacjenta |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Slowny opis przeciwcial. Pole powiazane (biznesowo) z grupa krwi i oznaczeniem krwi. |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
klucz obcy do tabeli SocialStatus |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Wskazuje na glówna karte pacjenta na podstawie której weryfikowany jest status |
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
Nazwa dokumentu zolnierza |
Name |
|
Code |
|
Data Type |
VARCHAR2(8) |
Mandatory |
No |
Comment |
Kod przydzialu wojskowego |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(64) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(24) |
Mandatory |
No |
Comment |
Wyliczana z kolumny CardNumber i zawiera dokladnie te sama wartosc. Aplikacja STER pobiera dane z tej kolumny i nie zostala jeszcze przystosowana do nowej nazwy kolumny zmienionej w Bug 202681. |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
data oznaczenia grupy krwi |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
FK->Person -- osoba odnotowujaca |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
czy wynik grupy krwi jest WIARYGODNY |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
osoba autoryzujaca zmiane grupy krwi pacjenta |
Name |
|
Code |
|
Data Type |
VARCHAR2(90) |
Mandatory |
No |
Comment |
Haslo do komunikacji na odleglosc |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Id platnika |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Pacjent ubezwlasnowolniony |
Name |
|
Code |
|
Data Type |
VARCHAR2(64) |
Mandatory |
No |
Comment |
Kartoteka pacjenta |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Wystapila choroba zakazna |
Name |
Code |
Primary |
X |
Name |
|
Code |
|
Primary |
Yes |
Comment |
|
|
|
|